MySQL, MySQLi, PDO?
October 5, 2009 · 28 views · 0 comments
Nearby In Time
Contestant on the First Question
September 22, 2009
The Polite Griefer
September 26, 2009
Corona Verse
October 4, 2009
Voices, Bots, and Serving Http
October 4, 2009
MySQL, MySQLi, PDO?
October 5, 2009
Fixing the media
October 5, 2009
Can you do that twist?
October 5, 2009
Wierd Art Thing
October 5, 2009
Oddness of Architecture
October 5, 2009
About
My head has been wrapped around optimizing my queries today for my inventory server back-end. I started with the MySQL extension, because I'm using MySQL. However, I wanted to create a wrapper that would handle common code. I got so far as to load scripts from the file system, but the problem came with parameters. I found that MySQLi was good for supporting the question mark "?" tag as a parameter so long as I specified the datatypes ahead of type for proper formatting. I believe I hit the jack pot when I discovered that PDO actually supported named parameters. I've condensed my code down to a third of it's original space and made things a bit more manageable. I need some sleep. From Dedric Mauriac via bloghud.com